﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PatientInformationDataSet" targetNamespace="http://tempuri.org/PatientInformationDataSet.xsd" xmlns:mstns="http://tempuri.org/PatientInformationDataSet.xsd" xmlns="http://tempuri.org/PatientInformationDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RISConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RISConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ViewLayer.Properties.Settings.GlobalReference.Default.RISConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientProfile_TableAdapter" GeneratorDataComponentClassName="PatientProfile_TableAdapter" Name="PatientProfile_" UserDataComponentName="PatientProfile_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientProfile_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PatientProfile_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([MrnId_] = @Original_MrnId_) AND ([MrnAssigningAuthority_] = @Original_MrnAssigningAuthority_) AND ((@IsNull_HealthcardId_ = 1 AND [HealthcardId_] IS NULL) OR ([HealthcardId_] = @Original_HealthcardId_)) AND ((@IsNull_HealthcardAssigningAuthority_ = 1 AND [HealthcardAssigningAuthority_] IS NULL) OR ([HealthcardAssigningAuthority_] = @Original_HealthcardAssigningAuthority_)) AND ((@IsNull_HealthcardVersionCode_ = 1 AND [HealthcardVersionCode_] IS NULL) OR ([HealthcardVersionCode_] = @Original_HealthcardVersionCode_)) AND ((@IsNull_HealthcardExpiryDate_ = 1 AND [HealthcardExpiryDate_] IS NULL) OR ([HealthcardExpiryDate_] = @Original_HealthcardExpiryDate_)) AND ([FamilyName_] = @Original_FamilyName_) AND ([GivenName_] = @Original_GivenName_) AND ((@IsNull_MiddleName_ = 1 AND [MiddleName_] IS NULL) OR ([MiddleName_] = @Original_MiddleName_)) AND ((@IsNull_Prefix_ = 1 AND [Prefix_] IS NULL) OR ([Prefix_] = @Original_Prefix_)) AND ((@IsNull_Suffix_ = 1 AND [Suffix_] IS NULL) OR ([Suffix_] = @Original_Suffix_)) AND ((@IsNull_Degree_ = 1 AND [Degree_] IS NULL) OR ([Degree_] = @Original_Degree_)) AND ((@IsNull_DateOfBirth_ = 1 AND [DateOfBirth_] IS NULL) OR ([DateOfBirth_] = @Original_DateOfBirth_)) AND ([Sex_] = @Original_Sex_) AND ((@IsNull_PrimaryLanguage_ = 1 AND [PrimaryLanguage_] IS NULL) OR ([PrimaryLanguage_] = @Original_PrimaryLanguage_)) AND ((@IsNull_Religion_ = 1 AND [Religion_] IS NULL) OR ([Religion_] = @Original_Religion_)) AND ([DeathIndicator_] = @Original_DeathIndicator_) AND ((@IsNull_TimeOfDeath_ = 1 AND [TimeOfDeath_] IS NULL) OR ([TimeOfDeath_] = @Original_TimeOfDeath_)) AND ([PatientOID_] = @Original_PatientOID_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MrnId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnId_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MrnAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardId_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardId_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HealthcardId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardId_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardAssigningAuthority_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardAssigningAuthority_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HealthcardAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardVersionCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardVersionCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HealthcardVersionCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardVersionCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardExpiryDate_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardExpiryDate_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_HealthcardExpiryDate_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HealthcardExpiryDate_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateOfBirth_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateOfBirth_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateOfBirth_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateOfBirth_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryLanguage_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryLanguage_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PrimaryLanguage_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryLanguage_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Religion_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Religion_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Religion_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Religion_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DeathIndicator_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DeathIndicator_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeOfDeath_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeOfDeath_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeOfDeath_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeOfDeath_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PatientProfile_] ([OID_], [Version_], [MrnId_], [MrnAssigningAuthority_], [HealthcardId_], [HealthcardAssigningAuthority_], [HealthcardVersionCode_], [HealthcardExpiryDate_], [FamilyName_], [GivenName_], [MiddleName_], [Prefix_], [Suffix_], [Degree_], [DateOfBirth_], [Sex_], [PrimaryLanguage_], [Religion_], [DeathIndicator_], [TimeOfDeath_], [PatientOID_]) VALUES (@OID_, @Version_, @MrnId_, @MrnAssigningAuthority_, @HealthcardId_, @HealthcardAssigningAuthority_, @HealthcardVersionCode_, @HealthcardExpiryDate_, @FamilyName_, @GivenName_, @MiddleName_, @Prefix_, @Suffix_, @Degree_, @DateOfBirth_, @Sex_, @PrimaryLanguage_, @Religion_, @DeathIndicator_, @TimeOfDeath_, @PatientOID_);
SELECT OID_, Version_, MrnId_, MrnAssigningAuthority_, HealthcardId_, HealthcardAssigningAuthority_, HealthcardVersionCode_, HealthcardExpiryDate_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, DateOfBirth_, Sex_, PrimaryLanguage_, Religion_, DeathIndicator_, TimeOfDeath_, PatientOID_ FROM PatientProfile_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MrnId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnId_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MrnAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HealthcardId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardId_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HealthcardAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HealthcardVersionCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardVersionCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@HealthcardExpiryDate_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HealthcardExpiryDate_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateOfBirth_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateOfBirth_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PrimaryLanguage_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryLanguage_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Religion_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Religion_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DeathIndicator_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DeathIndicator_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeOfDeath_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeOfDeath_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT OID_, Version_, MrnId_, MrnAssigningAuthority_, HealthcardId_, HealthcardAssigningAuthority_, HealthcardVersionCode_, HealthcardExpiryDate_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, DateOfBirth_, Sex_, PrimaryLanguage_, Religion_, DeathIndicator_, TimeOfDeath_, PatientOID_ FROM dbo.PatientProfile_ WHERE MrnId_ = @PID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PID" ColumnName="MrnId_" DataSourceName="RIS.dbo.PatientProfile_" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@PID" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="MrnId_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PatientProfile_] SET [OID_] = @OID_, [Version_] = @Version_, [MrnId_] = @MrnId_, [MrnAssigningAuthority_] = @MrnAssigningAuthority_, [HealthcardId_] = @HealthcardId_, [HealthcardAssigningAuthority_] = @HealthcardAssigningAuthority_, [HealthcardVersionCode_] = @HealthcardVersionCode_, [HealthcardExpiryDate_] = @HealthcardExpiryDate_, [FamilyName_] = @FamilyName_, [GivenName_] = @GivenName_, [MiddleName_] = @MiddleName_, [Prefix_] = @Prefix_, [Suffix_] = @Suffix_, [Degree_] = @Degree_, [DateOfBirth_] = @DateOfBirth_, [Sex_] = @Sex_, [PrimaryLanguage_] = @PrimaryLanguage_, [Religion_] = @Religion_, [DeathIndicator_] = @DeathIndicator_, [TimeOfDeath_] = @TimeOfDeath_, [PatientOID_] = @PatientOID_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([MrnId_] = @Original_MrnId_) AND ([MrnAssigningAuthority_] = @Original_MrnAssigningAuthority_) AND ((@IsNull_HealthcardId_ = 1 AND [HealthcardId_] IS NULL) OR ([HealthcardId_] = @Original_HealthcardId_)) AND ((@IsNull_HealthcardAssigningAuthority_ = 1 AND [HealthcardAssigningAuthority_] IS NULL) OR ([HealthcardAssigningAuthority_] = @Original_HealthcardAssigningAuthority_)) AND ((@IsNull_HealthcardVersionCode_ = 1 AND [HealthcardVersionCode_] IS NULL) OR ([HealthcardVersionCode_] = @Original_HealthcardVersionCode_)) AND ((@IsNull_HealthcardExpiryDate_ = 1 AND [HealthcardExpiryDate_] IS NULL) OR ([HealthcardExpiryDate_] = @Original_HealthcardExpiryDate_)) AND ([FamilyName_] = @Original_FamilyName_) AND ([GivenName_] = @Original_GivenName_) AND ((@IsNull_MiddleName_ = 1 AND [MiddleName_] IS NULL) OR ([MiddleName_] = @Original_MiddleName_)) AND ((@IsNull_Prefix_ = 1 AND [Prefix_] IS NULL) OR ([Prefix_] = @Original_Prefix_)) AND ((@IsNull_Suffix_ = 1 AND [Suffix_] IS NULL) OR ([Suffix_] = @Original_Suffix_)) AND ((@IsNull_Degree_ = 1 AND [Degree_] IS NULL) OR ([Degree_] = @Original_Degree_)) AND ((@IsNull_DateOfBirth_ = 1 AND [DateOfBirth_] IS NULL) OR ([DateOfBirth_] = @Original_DateOfBirth_)) AND ([Sex_] = @Original_Sex_) AND ((@IsNull_PrimaryLanguage_ = 1 AND [PrimaryLanguage_] IS NULL) OR ([PrimaryLanguage_] = @Original_PrimaryLanguage_)) AND ((@IsNull_Religion_ = 1 AND [Religion_] IS NULL) OR ([Religion_] = @Original_Religion_)) AND ([DeathIndicator_] = @Original_DeathIndicator_) AND ((@IsNull_TimeOfDeath_ = 1 AND [TimeOfDeath_] IS NULL) OR ([TimeOfDeath_] = @Original_TimeOfDeath_)) AND ([PatientOID_] = @Original_PatientOID_));
SELECT OID_, Version_, MrnId_, MrnAssigningAuthority_, HealthcardId_, HealthcardAssigningAuthority_, HealthcardVersionCode_, HealthcardExpiryDate_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, DateOfBirth_, Sex_, PrimaryLanguage_, Religion_, DeathIndicator_, TimeOfDeath_, PatientOID_ FROM PatientProfile_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MrnId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnId_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MrnAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HealthcardId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardId_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HealthcardAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HealthcardVersionCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardVersionCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@HealthcardExpiryDate_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HealthcardExpiryDate_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateOfBirth_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateOfBirth_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PrimaryLanguage_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryLanguage_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Religion_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Religion_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@DeathIndicator_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DeathIndicator_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TimeOfDeath_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeOfDeath_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MrnId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnId_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MrnAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MrnAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardId_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardId_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HealthcardId_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardId_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardAssigningAuthority_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardAssigningAuthority_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HealthcardAssigningAuthority_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardAssigningAuthority_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardVersionCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardVersionCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HealthcardVersionCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HealthcardVersionCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HealthcardExpiryDate_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HealthcardExpiryDate_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_HealthcardExpiryDate_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HealthcardExpiryDate_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateOfBirth_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateOfBirth_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateOfBirth_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateOfBirth_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryLanguage_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryLanguage_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PrimaryLanguage_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryLanguage_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Religion_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Religion_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Religion_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Religion_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_DeathIndicator_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="DeathIndicator_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeOfDeath_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeOfDeath_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TimeOfDeath_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TimeOfDeath_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="MrnId_" DataSetColumn="MrnId_" />
              <Mapping SourceColumn="MrnAssigningAuthority_" DataSetColumn="MrnAssigningAuthority_" />
              <Mapping SourceColumn="HealthcardId_" DataSetColumn="HealthcardId_" />
              <Mapping SourceColumn="HealthcardAssigningAuthority_" DataSetColumn="HealthcardAssigningAuthority_" />
              <Mapping SourceColumn="HealthcardVersionCode_" DataSetColumn="HealthcardVersionCode_" />
              <Mapping SourceColumn="HealthcardExpiryDate_" DataSetColumn="HealthcardExpiryDate_" />
              <Mapping SourceColumn="FamilyName_" DataSetColumn="FamilyName_" />
              <Mapping SourceColumn="GivenName_" DataSetColumn="GivenName_" />
              <Mapping SourceColumn="MiddleName_" DataSetColumn="MiddleName_" />
              <Mapping SourceColumn="Prefix_" DataSetColumn="Prefix_" />
              <Mapping SourceColumn="Suffix_" DataSetColumn="Suffix_" />
              <Mapping SourceColumn="Degree_" DataSetColumn="Degree_" />
              <Mapping SourceColumn="DateOfBirth_" DataSetColumn="DateOfBirth_" />
              <Mapping SourceColumn="Sex_" DataSetColumn="Sex_" />
              <Mapping SourceColumn="PrimaryLanguage_" DataSetColumn="PrimaryLanguage_" />
              <Mapping SourceColumn="Religion_" DataSetColumn="Religion_" />
              <Mapping SourceColumn="DeathIndicator_" DataSetColumn="DeathIndicator_" />
              <Mapping SourceColumn="TimeOfDeath_" DataSetColumn="TimeOfDeath_" />
              <Mapping SourceColumn="PatientOID_" DataSetColumn="PatientOID_" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientProfile_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySearch" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySearch" GeneratorSourceName="FillBySearch" GetMethodModifier="Public" GetMethodName="GetDataBySearch" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySearch" UserSourceName="FillBySearch">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        OID_, Version_, MrnId_, MrnAssigningAuthority_, HealthcardId_, HealthcardAssigningAuthority_, HealthcardVersionCode_, HealthcardExpiryDate_, FamilyName_, 
                         GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, DateOfBirth_, Sex_, PrimaryLanguage_, Religion_, DeathIndicator_, TimeOfDeath_, PatientOID_, 
                         IdDocumentNumber_
FROM            PatientProfile_
WHERE        (FamilyName_ LIKE @Apellido) AND (GivenName_ LIKE @Nombre) AND (MrnId_ LIKE @Pid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Apellido" ColumnName="FamilyName_" DataSourceName="RIS.dbo.PatientProfile_" DataTypeServer="nvarchar(40)" DbType="String" Direction="Input" ParameterName="@Apellido" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Nombre" ColumnName="GivenName_" DataSourceName="RIS.dbo.PatientProfile_" DataTypeServer="nvarchar(40)" DbType="String" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="NVarChar" Scale="0" Size="40" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Pid" ColumnName="MrnId_" DataSourceName="RIS.dbo.PatientProfile_" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@Pid" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="MrnId_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientProfileAddress_TableAdapter" GeneratorDataComponentClassName="PatientProfileAddress_TableAdapter" Name="PatientProfileAddress_" UserDataComponentName="PatientProfileAddress_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientProfileAddress_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PatientProfileAddress_] WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ([Street_] = @Original_Street_) AND ((@IsNull_Unit_ = 1 AND [Unit_] IS NULL) OR ([Unit_] = @Original_Unit_)) AND ([City_] = @Original_City_) AND ([Province_] = @Original_Province_) AND ((@IsNull_PostalCode_ = 1 AND [PostalCode_] IS NULL) OR ([PostalCode_] = @Original_PostalCode_)) AND ((@IsNull_Country_ = 1 AND [Country_] IS NULL) OR ([Country_] = @Original_Country_)) AND ([Type_] = @Original_Type_) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)) AND ([OID_] = @Original_OID_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Street_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Unit_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Province_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Province_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostalCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostalCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PostalCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Country_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Country_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Country_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PatientProfileAddress_] ([PatientProfileOID_], [Street_], [Unit_], [City_], [Province_], [PostalCode_], [Country_], [Type_], [ValidFrom_], [ValidUntil_], [OID_]) VALUES (@PatientProfileOID_, @Street_, @Unit_, @City_, @Province_, @PostalCode_, @Country_, @Type_, @ValidFrom_, @ValidUntil_, @OID_);
SELECT PatientProfileOID_, Street_, Unit_, City_, Province_, PostalCode_, Country_, Type_, ValidFrom_, ValidUntil_, OID_ FROM PatientProfileAddress_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Street_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Province_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Province_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PostalCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Country_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PatientProfileOID_, Street_, Unit_, City_, Province_, PostalCode_, Country_, Type_, ValidFrom_, ValidUntil_, OID_ FROM dbo.PatientProfileAddress_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PatientProfileAddress_] SET [PatientProfileOID_] = @PatientProfileOID_, [Street_] = @Street_, [Unit_] = @Unit_, [City_] = @City_, [Province_] = @Province_, [PostalCode_] = @PostalCode_, [Country_] = @Country_, [Type_] = @Type_, [ValidFrom_] = @ValidFrom_, [ValidUntil_] = @ValidUntil_, [OID_] = @OID_ WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ([Street_] = @Original_Street_) AND ((@IsNull_Unit_ = 1 AND [Unit_] IS NULL) OR ([Unit_] = @Original_Unit_)) AND ([City_] = @Original_City_) AND ([Province_] = @Original_Province_) AND ((@IsNull_PostalCode_ = 1 AND [PostalCode_] IS NULL) OR ([PostalCode_] = @Original_PostalCode_)) AND ((@IsNull_Country_ = 1 AND [Country_] IS NULL) OR ([Country_] = @Original_Country_)) AND ([Type_] = @Original_Type_) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)) AND ([OID_] = @Original_OID_));
SELECT PatientProfileOID_, Street_, Unit_, City_, Province_, PostalCode_, Country_, Type_, ValidFrom_, ValidUntil_, OID_ FROM PatientProfileAddress_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Street_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Unit_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Province_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Province_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PostalCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Country_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Street_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Unit_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Unit_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Unit_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Unit_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Province_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Province_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PostalCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PostalCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PostalCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PostalCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Country_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Country_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Country_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Country_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PatientProfileOID_" DataSetColumn="PatientProfileOID_" />
              <Mapping SourceColumn="Street_" DataSetColumn="Street_" />
              <Mapping SourceColumn="Unit_" DataSetColumn="Unit_" />
              <Mapping SourceColumn="City_" DataSetColumn="City_" />
              <Mapping SourceColumn="Province_" DataSetColumn="Province_" />
              <Mapping SourceColumn="PostalCode_" DataSetColumn="PostalCode_" />
              <Mapping SourceColumn="Country_" DataSetColumn="Country_" />
              <Mapping SourceColumn="Type_" DataSetColumn="Type_" />
              <Mapping SourceColumn="ValidFrom_" DataSetColumn="ValidFrom_" />
              <Mapping SourceColumn="ValidUntil_" DataSetColumn="ValidUntil_" />
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientProfileContactPerson_TableAdapter" GeneratorDataComponentClassName="PatientProfileContactPerson_TableAdapter" Name="PatientProfileContactPerson_" UserDataComponentName="PatientProfileContactPerson_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientProfileContactPerson_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PatientProfileContactPerson_] WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ([Name_] = @Original_Name_) AND ((@IsNull_Address_ = 1 AND [Address_] IS NULL) OR ([Address_] = @Original_Address_)) AND ((@IsNull_HomePhone_ = 1 AND [HomePhone_] IS NULL) OR ([HomePhone_] = @Original_HomePhone_)) AND ((@IsNull_BusinessPhone_ = 1 AND [BusinessPhone_] IS NULL) OR ([BusinessPhone_] = @Original_BusinessPhone_)) AND ([Type_] = @Original_Type_) AND ([Relationship_] = @Original_Relationship_) AND ([OID_] = @Original_OID_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HomePhone_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HomePhone_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HomePhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HomePhone_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BusinessPhone_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BusinessPhone_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BusinessPhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BusinessPhone_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Relationship_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Relationship_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PatientProfileContactPerson_] ([PatientProfileOID_], [Name_], [Address_], [HomePhone_], [BusinessPhone_], [Type_], [Relationship_], [OID_]) VALUES (@PatientProfileOID_, @Name_, @Address_, @HomePhone_, @BusinessPhone_, @Type_, @Relationship_, @OID_);
SELECT PatientProfileOID_, Name_, Address_, HomePhone_, BusinessPhone_, Type_, Relationship_, OID_ FROM PatientProfileContactPerson_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HomePhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HomePhone_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BusinessPhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BusinessPhone_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Relationship_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Relationship_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PatientProfileOID_, Name_, Address_, HomePhone_, BusinessPhone_, Type_, Relationship_, OID_ FROM dbo.PatientProfileContactPerson_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PatientProfileContactPerson_] SET [PatientProfileOID_] = @PatientProfileOID_, [Name_] = @Name_, [Address_] = @Address_, [HomePhone_] = @HomePhone_, [BusinessPhone_] = @BusinessPhone_, [Type_] = @Type_, [Relationship_] = @Relationship_, [OID_] = @OID_ WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ([Name_] = @Original_Name_) AND ((@IsNull_Address_ = 1 AND [Address_] IS NULL) OR ([Address_] = @Original_Address_)) AND ((@IsNull_HomePhone_ = 1 AND [HomePhone_] IS NULL) OR ([HomePhone_] = @Original_HomePhone_)) AND ((@IsNull_BusinessPhone_ = 1 AND [BusinessPhone_] IS NULL) OR ([BusinessPhone_] = @Original_BusinessPhone_)) AND ([Type_] = @Original_Type_) AND ([Relationship_] = @Original_Relationship_) AND ([OID_] = @Original_OID_));
SELECT PatientProfileOID_, Name_, Address_, HomePhone_, BusinessPhone_, Type_, Relationship_, OID_ FROM PatientProfileContactPerson_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HomePhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HomePhone_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BusinessPhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BusinessPhone_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Relationship_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Relationship_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HomePhone_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HomePhone_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HomePhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HomePhone_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BusinessPhone_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BusinessPhone_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BusinessPhone_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BusinessPhone_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Relationship_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Relationship_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PatientProfileOID_" DataSetColumn="PatientProfileOID_" />
              <Mapping SourceColumn="Name_" DataSetColumn="Name_" />
              <Mapping SourceColumn="Address_" DataSetColumn="Address_" />
              <Mapping SourceColumn="HomePhone_" DataSetColumn="HomePhone_" />
              <Mapping SourceColumn="BusinessPhone_" DataSetColumn="BusinessPhone_" />
              <Mapping SourceColumn="Type_" DataSetColumn="Type_" />
              <Mapping SourceColumn="Relationship_" DataSetColumn="Relationship_" />
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientProfileEmailAddress_TableAdapter" GeneratorDataComponentClassName="PatientProfileEmailAddress_TableAdapter" Name="PatientProfileEmailAddress_" UserDataComponentName="PatientProfileEmailAddress_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientProfileEmailAddress_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PatientProfileEmailAddress_] WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ([Address_] = @Original_Address_) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)) AND ([OID_] = @Original_OID_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PatientProfileEmailAddress_] ([PatientProfileOID_], [Address_], [ValidFrom_], [ValidUntil_], [OID_]) VALUES (@PatientProfileOID_, @Address_, @ValidFrom_, @ValidUntil_, @OID_);
SELECT PatientProfileOID_, Address_, ValidFrom_, ValidUntil_, OID_ FROM PatientProfileEmailAddress_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PatientProfileOID_, Address_, ValidFrom_, ValidUntil_, OID_ FROM dbo.PatientProfileEmailAddress_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PatientProfileEmailAddress_] SET [PatientProfileOID_] = @PatientProfileOID_, [Address_] = @Address_, [ValidFrom_] = @ValidFrom_, [ValidUntil_] = @ValidUntil_, [OID_] = @OID_ WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ([Address_] = @Original_Address_) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)) AND ([OID_] = @Original_OID_));
SELECT PatientProfileOID_, Address_, ValidFrom_, ValidUntil_, OID_ FROM PatientProfileEmailAddress_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PatientProfileOID_" DataSetColumn="PatientProfileOID_" />
              <Mapping SourceColumn="Address_" DataSetColumn="Address_" />
              <Mapping SourceColumn="ValidFrom_" DataSetColumn="ValidFrom_" />
              <Mapping SourceColumn="ValidUntil_" DataSetColumn="ValidUntil_" />
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientProfileTelephoneNumber_TableAdapter" GeneratorDataComponentClassName="PatientProfileTelephoneNumber_TableAdapter" Name="PatientProfileTelephoneNumber_" UserDataComponentName="PatientProfileTelephoneNumber_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientProfileTelephoneNumber_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PatientProfileTelephoneNumber_] WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ((@IsNull_CountryCode_ = 1 AND [CountryCode_] IS NULL) OR ([CountryCode_] = @Original_CountryCode_)) AND ((@IsNull_AreaCode_ = 1 AND [AreaCode_] IS NULL) OR ([AreaCode_] = @Original_AreaCode_)) AND ([Number_] = @Original_Number_) AND ((@IsNull_Extension_ = 1 AND [Extension_] IS NULL) OR ([Extension_] = @Original_Extension_)) AND ([Use_] = @Original_Use_) AND ([Equipment_] = @Original_Equipment_) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)) AND ([OID_] = @Original_OID_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountryCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CountryCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CountryCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AreaCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AreaCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AreaCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AreaCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Number_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Number_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Extension_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Extension_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Extension_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Extension_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Use_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Use_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Equipment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Equipment_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PatientProfileTelephoneNumber_] ([PatientProfileOID_], [CountryCode_], [AreaCode_], [Number_], [Extension_], [Use_], [Equipment_], [ValidFrom_], [ValidUntil_], [OID_]) VALUES (@PatientProfileOID_, @CountryCode_, @AreaCode_, @Number_, @Extension_, @Use_, @Equipment_, @ValidFrom_, @ValidUntil_, @OID_);
SELECT PatientProfileOID_, CountryCode_, AreaCode_, Number_, Extension_, Use_, Equipment_, ValidFrom_, ValidUntil_, OID_ FROM PatientProfileTelephoneNumber_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CountryCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CountryCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AreaCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AreaCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Number_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Number_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Extension_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Extension_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Use_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Use_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Equipment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Equipment_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PatientProfileOID_, CountryCode_, AreaCode_, Number_, Extension_, Use_, Equipment_, ValidFrom_, ValidUntil_, OID_ FROM dbo.PatientProfileTelephoneNumber_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PatientProfileTelephoneNumber_] SET [PatientProfileOID_] = @PatientProfileOID_, [CountryCode_] = @CountryCode_, [AreaCode_] = @AreaCode_, [Number_] = @Number_, [Extension_] = @Extension_, [Use_] = @Use_, [Equipment_] = @Equipment_, [ValidFrom_] = @ValidFrom_, [ValidUntil_] = @ValidUntil_, [OID_] = @OID_ WHERE (([PatientProfileOID_] = @Original_PatientProfileOID_) AND ((@IsNull_CountryCode_ = 1 AND [CountryCode_] IS NULL) OR ([CountryCode_] = @Original_CountryCode_)) AND ((@IsNull_AreaCode_ = 1 AND [AreaCode_] IS NULL) OR ([AreaCode_] = @Original_AreaCode_)) AND ([Number_] = @Original_Number_) AND ((@IsNull_Extension_ = 1 AND [Extension_] IS NULL) OR ([Extension_] = @Original_Extension_)) AND ([Use_] = @Original_Use_) AND ([Equipment_] = @Original_Equipment_) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)) AND ([OID_] = @Original_OID_));
SELECT PatientProfileOID_, CountryCode_, AreaCode_, Number_, Extension_, Use_, Equipment_, ValidFrom_, ValidUntil_, OID_ FROM PatientProfileTelephoneNumber_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CountryCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CountryCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AreaCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AreaCode_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Number_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Number_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Extension_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Extension_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Use_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Use_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Equipment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Equipment_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientProfileOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientProfileOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CountryCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CountryCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CountryCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CountryCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AreaCode_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AreaCode_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AreaCode_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AreaCode_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Number_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Number_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Extension_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Extension_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Extension_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Extension_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Use_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Use_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Equipment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Equipment_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PatientProfileOID_" DataSetColumn="PatientProfileOID_" />
              <Mapping SourceColumn="CountryCode_" DataSetColumn="CountryCode_" />
              <Mapping SourceColumn="AreaCode_" DataSetColumn="AreaCode_" />
              <Mapping SourceColumn="Number_" DataSetColumn="Number_" />
              <Mapping SourceColumn="Extension_" DataSetColumn="Extension_" />
              <Mapping SourceColumn="Use_" DataSetColumn="Use_" />
              <Mapping SourceColumn="Equipment_" DataSetColumn="Equipment_" />
              <Mapping SourceColumn="ValidFrom_" DataSetColumn="ValidFrom_" />
              <Mapping SourceColumn="ValidUntil_" DataSetColumn="ValidUntil_" />
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientNote_TableAdapter" GeneratorDataComponentClassName="PatientNote_TableAdapter" Name="PatientNote_" UserDataComponentName="PatientNote_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientNote_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PatientNote_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([PatientOID_] = @Original_PatientOID_) AND ([CreationTime_] = @Original_CreationTime_) AND ([AuthorOID_] = @Original_AuthorOID_) AND ([CategoryOID_] = @Original_CategoryOID_) AND ((@IsNull_Comment_ = 1 AND [Comment_] IS NULL) OR ([Comment_] = @Original_Comment_)) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreationTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_AuthorOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AuthorOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CategoryOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PatientNote_] ([OID_], [Version_], [PatientOID_], [CreationTime_], [AuthorOID_], [CategoryOID_], [Comment_], [ValidFrom_], [ValidUntil_]) VALUES (@OID_, @Version_, @PatientOID_, @CreationTime_, @AuthorOID_, @CategoryOID_, @Comment_, @ValidFrom_, @ValidUntil_);
SELECT OID_, Version_, PatientOID_, CreationTime_, AuthorOID_, CategoryOID_, Comment_, ValidFrom_, ValidUntil_ FROM PatientNote_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreationTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AuthorOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AuthorOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CategoryOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT OID_, Version_, PatientOID_, CreationTime_, AuthorOID_, CategoryOID_, Comment_, ValidFrom_, ValidUntil_ FROM dbo.PatientNote_ WHERE PatientOID_ = @oid</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="oid" ColumnName="PatientOID_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@oid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PatientNote_] SET [OID_] = @OID_, [Version_] = @Version_, [PatientOID_] = @PatientOID_, [CreationTime_] = @CreationTime_, [AuthorOID_] = @AuthorOID_, [CategoryOID_] = @CategoryOID_, [Comment_] = @Comment_, [ValidFrom_] = @ValidFrom_, [ValidUntil_] = @ValidUntil_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([PatientOID_] = @Original_PatientOID_) AND ([CreationTime_] = @Original_CreationTime_) AND ([AuthorOID_] = @Original_AuthorOID_) AND ([CategoryOID_] = @Original_CategoryOID_) AND ((@IsNull_Comment_ = 1 AND [Comment_] IS NULL) OR ([Comment_] = @Original_Comment_)) AND ((@IsNull_ValidFrom_ = 1 AND [ValidFrom_] IS NULL) OR ([ValidFrom_] = @Original_ValidFrom_)) AND ((@IsNull_ValidUntil_ = 1 AND [ValidUntil_] IS NULL) OR ([ValidUntil_] = @Original_ValidUntil_)));
SELECT OID_, Version_, PatientOID_, CreationTime_, AuthorOID_, CategoryOID_, Comment_, ValidFrom_, ValidUntil_ FROM PatientNote_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreationTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AuthorOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AuthorOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@CategoryOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PatientOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreationTime_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreationTime_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_AuthorOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AuthorOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_CategoryOID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryOID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidFrom_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidFrom_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidFrom_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ValidUntil_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ValidUntil_" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ValidUntil_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="PatientOID_" DataSetColumn="PatientOID_" />
              <Mapping SourceColumn="CreationTime_" DataSetColumn="CreationTime_" />
              <Mapping SourceColumn="AuthorOID_" DataSetColumn="AuthorOID_" />
              <Mapping SourceColumn="CategoryOID_" DataSetColumn="CategoryOID_" />
              <Mapping SourceColumn="Comment_" DataSetColumn="Comment_" />
              <Mapping SourceColumn="ValidFrom_" DataSetColumn="ValidFrom_" />
              <Mapping SourceColumn="ValidUntil_" DataSetColumn="ValidUntil_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientNoteCategory_TableAdapter" GeneratorDataComponentClassName="PatientNoteCategory_TableAdapter" Name="PatientNoteCategory_" UserDataComponentName="PatientNoteCategory_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientNoteCategory_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PatientNoteCategory_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([Name_] = @Original_Name_) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ([Severity_] = @Original_Severity_) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Severity_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PatientNoteCategory_] ([OID_], [Version_], [Name_], [Description_], [Severity_], [Deactivated_]) VALUES (@OID_, @Version_, @Name_, @Description_, @Severity_, @Deactivated_);
SELECT OID_, Version_, Name_, Description_, Severity_, Deactivated_ FROM PatientNoteCategory_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Severity_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OID_, Version_, Name_, Description_, Severity_, Deactivated_ FROM dbo.PatientNoteCategory_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PatientNoteCategory_] SET [OID_] = @OID_, [Version_] = @Version_, [Name_] = @Name_, [Description_] = @Description_, [Severity_] = @Severity_, [Deactivated_] = @Deactivated_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([Name_] = @Original_Name_) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ([Severity_] = @Original_Severity_) AND ([Deactivated_] = @Original_Deactivated_));
SELECT OID_, Version_, Name_, Description_, Severity_, Deactivated_ FROM PatientNoteCategory_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Severity_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Severity_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="Name_" DataSetColumn="Name_" />
              <Mapping SourceColumn="Description_" DataSetColumn="Description_" />
              <Mapping SourceColumn="Severity_" DataSetColumn="Severity_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientNoteCategory_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OID_, Version_, Name_, Description_, Severity_, Deactivated_ FROM dbo.PatientNoteCategory_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Patient_TableAdapter" GeneratorDataComponentClassName="Patient_TableAdapter" Name="Patient_" UserDataComponentName="Patient_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.Patient_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Patient_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Patient_] ([OID_], [Version_]) VALUES (@OID_, @Version_);
SELECT OID_, Version_ FROM Patient_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OID_, Version_ FROM dbo.Patient_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Patient_] SET [OID_] = @OID_, [Version_] = @Version_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_));
SELECT OID_, Version_ FROM Patient_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InformationAuthorityEnum_TableAdapter" GeneratorDataComponentClassName="InformationAuthorityEnum_TableAdapter" Name="InformationAuthorityEnum_" UserDataComponentName="InformationAuthorityEnum_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.InformationAuthorityEnum_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[InformationAuthorityEnum_] WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[InformationAuthorityEnum_] ([Code_], [Value_], [Description_], [DisplayOrder_], [Deactivated_]) VALUES (@Code_, @Value_, @Description_, @DisplayOrder_, @Deactivated_);
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM InformationAuthorityEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM dbo.InformationAuthorityEnum_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[InformationAuthorityEnum_] SET [Code_] = @Code_, [Value_] = @Value_, [Description_] = @Description_, [DisplayOrder_] = @DisplayOrder_, [Deactivated_] = @Deactivated_ WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_));
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM InformationAuthorityEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code_" DataSetColumn="Code_" />
              <Mapping SourceColumn="Value_" DataSetColumn="Value_" />
              <Mapping SourceColumn="Description_" DataSetColumn="Description_" />
              <Mapping SourceColumn="DisplayOrder_" DataSetColumn="DisplayOrder_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PatientInformationDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="PatientInformationDataSet" msprop:Generator_UserDSName="PatientInformationDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PatientProfile_" msprop:Generator_TableClassName="PatientProfile_DataTable" msprop:Generator_TableVarName="tablePatientProfile_" msprop:Generator_TablePropName="PatientProfile_" msprop:Generator_RowDeletingName="PatientProfile_RowDeleting" msprop:Generator_UserTableName="PatientProfile_" msprop:Generator_RowChangingName="PatientProfile_RowChanging" msprop:Generator_RowEvHandlerName="PatientProfile_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientProfile_RowDeleted" msprop:Generator_RowEvArgName="PatientProfile_RowChangeEvent" msprop:Generator_RowChangedName="PatientProfile_RowChanged" msprop:Generator_RowClassName="PatientProfile_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="MrnId_" msprop:Generator_ColumnVarNameInTable="columnMrnId_" msprop:Generator_ColumnPropNameInRow="MrnId_" msprop:Generator_ColumnPropNameInTable="MrnId_Column" msprop:Generator_UserColumnName="MrnId_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MrnAssigningAuthority_" msprop:Generator_ColumnVarNameInTable="columnMrnAssigningAuthority_" msprop:Generator_ColumnPropNameInRow="MrnAssigningAuthority_" msprop:Generator_ColumnPropNameInTable="MrnAssigningAuthority_Column" msprop:Generator_UserColumnName="MrnAssigningAuthority_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HealthcardId_" msprop:Generator_ColumnVarNameInTable="columnHealthcardId_" msprop:Generator_ColumnPropNameInRow="HealthcardId_" msprop:Generator_ColumnPropNameInTable="HealthcardId_Column" msprop:Generator_UserColumnName="HealthcardId_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HealthcardAssigningAuthority_" msprop:Generator_ColumnVarNameInTable="columnHealthcardAssigningAuthority_" msprop:Generator_ColumnPropNameInRow="HealthcardAssigningAuthority_" msprop:Generator_ColumnPropNameInTable="HealthcardAssigningAuthority_Column" msprop:Generator_UserColumnName="HealthcardAssigningAuthority_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HealthcardVersionCode_" msprop:Generator_ColumnVarNameInTable="columnHealthcardVersionCode_" msprop:Generator_ColumnPropNameInRow="HealthcardVersionCode_" msprop:Generator_ColumnPropNameInTable="HealthcardVersionCode_Column" msprop:Generator_UserColumnName="HealthcardVersionCode_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HealthcardExpiryDate_" msprop:Generator_ColumnVarNameInTable="columnHealthcardExpiryDate_" msprop:Generator_ColumnPropNameInRow="HealthcardExpiryDate_" msprop:Generator_ColumnPropNameInTable="HealthcardExpiryDate_Column" msprop:Generator_UserColumnName="HealthcardExpiryDate_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="FamilyName_" msprop:Generator_ColumnVarNameInTable="columnFamilyName_" msprop:Generator_ColumnPropNameInRow="FamilyName_" msprop:Generator_ColumnPropNameInTable="FamilyName_Column" msprop:Generator_UserColumnName="FamilyName_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GivenName_" msprop:Generator_ColumnVarNameInTable="columnGivenName_" msprop:Generator_ColumnPropNameInRow="GivenName_" msprop:Generator_ColumnPropNameInTable="GivenName_Column" msprop:Generator_UserColumnName="GivenName_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName_" msprop:Generator_ColumnVarNameInTable="columnMiddleName_" msprop:Generator_ColumnPropNameInRow="MiddleName_" msprop:Generator_ColumnPropNameInTable="MiddleName_Column" msprop:Generator_UserColumnName="MiddleName_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prefix_" msprop:Generator_ColumnVarNameInTable="columnPrefix_" msprop:Generator_ColumnPropNameInRow="Prefix_" msprop:Generator_ColumnPropNameInTable="Prefix_Column" msprop:Generator_UserColumnName="Prefix_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Suffix_" msprop:Generator_ColumnVarNameInTable="columnSuffix_" msprop:Generator_ColumnPropNameInRow="Suffix_" msprop:Generator_ColumnPropNameInTable="Suffix_Column" msprop:Generator_UserColumnName="Suffix_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Degree_" msprop:Generator_ColumnVarNameInTable="columnDegree_" msprop:Generator_ColumnPropNameInRow="Degree_" msprop:Generator_ColumnPropNameInTable="Degree_Column" msprop:Generator_UserColumnName="Degree_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateOfBirth_" msprop:Generator_ColumnVarNameInTable="columnDateOfBirth_" msprop:Generator_ColumnPropNameInRow="DateOfBirth_" msprop:Generator_ColumnPropNameInTable="DateOfBirth_Column" msprop:Generator_UserColumnName="DateOfBirth_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Sex_" msprop:Generator_ColumnVarNameInTable="columnSex_" msprop:Generator_ColumnPropNameInRow="Sex_" msprop:Generator_ColumnPropNameInTable="Sex_Column" msprop:Generator_UserColumnName="Sex_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrimaryLanguage_" msprop:Generator_ColumnVarNameInTable="columnPrimaryLanguage_" msprop:Generator_ColumnPropNameInRow="PrimaryLanguage_" msprop:Generator_ColumnPropNameInTable="PrimaryLanguage_Column" msprop:Generator_UserColumnName="PrimaryLanguage_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Religion_" msprop:Generator_ColumnVarNameInTable="columnReligion_" msprop:Generator_ColumnPropNameInRow="Religion_" msprop:Generator_ColumnPropNameInTable="Religion_Column" msprop:Generator_UserColumnName="Religion_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DeathIndicator_" msprop:Generator_ColumnVarNameInTable="columnDeathIndicator_" msprop:Generator_ColumnPropNameInRow="DeathIndicator_" msprop:Generator_ColumnPropNameInTable="DeathIndicator_Column" msprop:Generator_UserColumnName="DeathIndicator_" type="xs:boolean" />
              <xs:element name="TimeOfDeath_" msprop:Generator_ColumnVarNameInTable="columnTimeOfDeath_" msprop:Generator_ColumnPropNameInRow="TimeOfDeath_" msprop:Generator_ColumnPropNameInTable="TimeOfDeath_Column" msprop:Generator_UserColumnName="TimeOfDeath_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PatientOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPatientOID_" msprop:Generator_ColumnPropNameInRow="PatientOID_" msprop:Generator_ColumnPropNameInTable="PatientOID_Column" msprop:Generator_UserColumnName="PatientOID_" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PatientProfileAddress_" msprop:Generator_TableClassName="PatientProfileAddress_DataTable" msprop:Generator_TableVarName="tablePatientProfileAddress_" msprop:Generator_TablePropName="PatientProfileAddress_" msprop:Generator_RowDeletingName="PatientProfileAddress_RowDeleting" msprop:Generator_UserTableName="PatientProfileAddress_" msprop:Generator_RowChangingName="PatientProfileAddress_RowChanging" msprop:Generator_RowEvHandlerName="PatientProfileAddress_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientProfileAddress_RowDeleted" msprop:Generator_RowEvArgName="PatientProfileAddress_RowChangeEvent" msprop:Generator_RowChangedName="PatientProfileAddress_RowChanged" msprop:Generator_RowClassName="PatientProfileAddress_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PatientProfileOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPatientProfileOID_" msprop:Generator_ColumnPropNameInRow="PatientProfileOID_" msprop:Generator_ColumnPropNameInTable="PatientProfileOID_Column" msprop:Generator_UserColumnName="PatientProfileOID_" type="xs:string" />
              <xs:element name="Street_" msprop:Generator_ColumnVarNameInTable="columnStreet_" msprop:Generator_ColumnPropNameInRow="Street_" msprop:Generator_ColumnPropNameInTable="Street_Column" msprop:Generator_UserColumnName="Street_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Unit_" msprop:Generator_ColumnVarNameInTable="columnUnit_" msprop:Generator_ColumnPropNameInRow="Unit_" msprop:Generator_ColumnPropNameInTable="Unit_Column" msprop:Generator_UserColumnName="Unit_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City_" msprop:Generator_ColumnVarNameInTable="columnCity_" msprop:Generator_ColumnPropNameInRow="City_" msprop:Generator_ColumnPropNameInTable="City_Column" msprop:Generator_UserColumnName="City_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Province_" msprop:Generator_ColumnVarNameInTable="columnProvince_" msprop:Generator_ColumnPropNameInRow="Province_" msprop:Generator_ColumnPropNameInTable="Province_Column" msprop:Generator_UserColumnName="Province_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostalCode_" msprop:Generator_ColumnVarNameInTable="columnPostalCode_" msprop:Generator_ColumnPropNameInRow="PostalCode_" msprop:Generator_ColumnPropNameInTable="PostalCode_Column" msprop:Generator_UserColumnName="PostalCode_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country_" msprop:Generator_ColumnVarNameInTable="columnCountry_" msprop:Generator_ColumnPropNameInRow="Country_" msprop:Generator_ColumnPropNameInTable="Country_Column" msprop:Generator_UserColumnName="Country_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type_" msprop:Generator_ColumnVarNameInTable="columnType_" msprop:Generator_ColumnPropNameInRow="Type_" msprop:Generator_ColumnPropNameInTable="Type_Column" msprop:Generator_UserColumnName="Type_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidFrom_" msprop:Generator_ColumnVarNameInTable="columnValidFrom_" msprop:Generator_ColumnPropNameInRow="ValidFrom_" msprop:Generator_ColumnPropNameInTable="ValidFrom_Column" msprop:Generator_UserColumnName="ValidFrom_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ValidUntil_" msprop:Generator_ColumnVarNameInTable="columnValidUntil_" msprop:Generator_ColumnPropNameInRow="ValidUntil_" msprop:Generator_ColumnPropNameInTable="ValidUntil_Column" msprop:Generator_UserColumnName="ValidUntil_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PatientProfileContactPerson_" msprop:Generator_TableClassName="PatientProfileContactPerson_DataTable" msprop:Generator_TableVarName="tablePatientProfileContactPerson_" msprop:Generator_TablePropName="PatientProfileContactPerson_" msprop:Generator_RowDeletingName="PatientProfileContactPerson_RowDeleting" msprop:Generator_UserTableName="PatientProfileContactPerson_" msprop:Generator_RowChangingName="PatientProfileContactPerson_RowChanging" msprop:Generator_RowEvHandlerName="PatientProfileContactPerson_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientProfileContactPerson_RowDeleted" msprop:Generator_RowEvArgName="PatientProfileContactPerson_RowChangeEvent" msprop:Generator_RowChangedName="PatientProfileContactPerson_RowChanged" msprop:Generator_RowClassName="PatientProfileContactPerson_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PatientProfileOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPatientProfileOID_" msprop:Generator_ColumnPropNameInRow="PatientProfileOID_" msprop:Generator_ColumnPropNameInTable="PatientProfileOID_Column" msprop:Generator_UserColumnName="PatientProfileOID_" type="xs:string" />
              <xs:element name="Name_" msprop:Generator_ColumnVarNameInTable="columnName_" msprop:Generator_ColumnPropNameInRow="Name_" msprop:Generator_ColumnPropNameInTable="Name_Column" msprop:Generator_UserColumnName="Name_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address_" msprop:Generator_ColumnVarNameInTable="columnAddress_" msprop:Generator_ColumnPropNameInRow="Address_" msprop:Generator_ColumnPropNameInTable="Address_Column" msprop:Generator_UserColumnName="Address_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HomePhone_" msprop:Generator_ColumnVarNameInTable="columnHomePhone_" msprop:Generator_ColumnPropNameInRow="HomePhone_" msprop:Generator_ColumnPropNameInTable="HomePhone_Column" msprop:Generator_UserColumnName="HomePhone_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BusinessPhone_" msprop:Generator_ColumnVarNameInTable="columnBusinessPhone_" msprop:Generator_ColumnPropNameInRow="BusinessPhone_" msprop:Generator_ColumnPropNameInTable="BusinessPhone_Column" msprop:Generator_UserColumnName="BusinessPhone_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type_" msprop:Generator_ColumnVarNameInTable="columnType_" msprop:Generator_ColumnPropNameInRow="Type_" msprop:Generator_ColumnPropNameInTable="Type_Column" msprop:Generator_UserColumnName="Type_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Relationship_" msprop:Generator_ColumnVarNameInTable="columnRelationship_" msprop:Generator_ColumnPropNameInRow="Relationship_" msprop:Generator_ColumnPropNameInTable="Relationship_Column" msprop:Generator_UserColumnName="Relationship_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PatientProfileEmailAddress_" msprop:Generator_TableClassName="PatientProfileEmailAddress_DataTable" msprop:Generator_TableVarName="tablePatientProfileEmailAddress_" msprop:Generator_TablePropName="PatientProfileEmailAddress_" msprop:Generator_RowDeletingName="PatientProfileEmailAddress_RowDeleting" msprop:Generator_UserTableName="PatientProfileEmailAddress_" msprop:Generator_RowChangingName="PatientProfileEmailAddress_RowChanging" msprop:Generator_RowEvHandlerName="PatientProfileEmailAddress_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientProfileEmailAddress_RowDeleted" msprop:Generator_RowEvArgName="PatientProfileEmailAddress_RowChangeEvent" msprop:Generator_RowChangedName="PatientProfileEmailAddress_RowChanged" msprop:Generator_RowClassName="PatientProfileEmailAddress_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PatientProfileOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPatientProfileOID_" msprop:Generator_ColumnPropNameInRow="PatientProfileOID_" msprop:Generator_ColumnPropNameInTable="PatientProfileOID_Column" msprop:Generator_UserColumnName="PatientProfileOID_" type="xs:string" />
              <xs:element name="Address_" msprop:Generator_ColumnVarNameInTable="columnAddress_" msprop:Generator_ColumnPropNameInRow="Address_" msprop:Generator_ColumnPropNameInTable="Address_Column" msprop:Generator_UserColumnName="Address_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidFrom_" msprop:Generator_ColumnVarNameInTable="columnValidFrom_" msprop:Generator_ColumnPropNameInRow="ValidFrom_" msprop:Generator_ColumnPropNameInTable="ValidFrom_Column" msprop:Generator_UserColumnName="ValidFrom_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ValidUntil_" msprop:Generator_ColumnVarNameInTable="columnValidUntil_" msprop:Generator_ColumnPropNameInRow="ValidUntil_" msprop:Generator_ColumnPropNameInTable="ValidUntil_Column" msprop:Generator_UserColumnName="ValidUntil_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PatientProfileTelephoneNumber_" msprop:Generator_TableClassName="PatientProfileTelephoneNumber_DataTable" msprop:Generator_TableVarName="tablePatientProfileTelephoneNumber_" msprop:Generator_TablePropName="PatientProfileTelephoneNumber_" msprop:Generator_RowDeletingName="PatientProfileTelephoneNumber_RowDeleting" msprop:Generator_UserTableName="PatientProfileTelephoneNumber_" msprop:Generator_RowChangingName="PatientProfileTelephoneNumber_RowChanging" msprop:Generator_RowEvHandlerName="PatientProfileTelephoneNumber_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientProfileTelephoneNumber_RowDeleted" msprop:Generator_RowEvArgName="PatientProfileTelephoneNumber_RowChangeEvent" msprop:Generator_RowChangedName="PatientProfileTelephoneNumber_RowChanged" msprop:Generator_RowClassName="PatientProfileTelephoneNumber_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PatientProfileOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPatientProfileOID_" msprop:Generator_ColumnPropNameInRow="PatientProfileOID_" msprop:Generator_ColumnPropNameInTable="PatientProfileOID_Column" msprop:Generator_UserColumnName="PatientProfileOID_" type="xs:string" />
              <xs:element name="CountryCode_" msprop:Generator_ColumnVarNameInTable="columnCountryCode_" msprop:Generator_ColumnPropNameInRow="CountryCode_" msprop:Generator_ColumnPropNameInTable="CountryCode_Column" msprop:Generator_UserColumnName="CountryCode_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AreaCode_" msprop:Generator_ColumnVarNameInTable="columnAreaCode_" msprop:Generator_ColumnPropNameInRow="AreaCode_" msprop:Generator_ColumnPropNameInTable="AreaCode_Column" msprop:Generator_UserColumnName="AreaCode_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Number_" msprop:Generator_ColumnVarNameInTable="columnNumber_" msprop:Generator_ColumnPropNameInRow="Number_" msprop:Generator_ColumnPropNameInTable="Number_Column" msprop:Generator_UserColumnName="Number_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Extension_" msprop:Generator_ColumnVarNameInTable="columnExtension_" msprop:Generator_ColumnPropNameInRow="Extension_" msprop:Generator_ColumnPropNameInTable="Extension_Column" msprop:Generator_UserColumnName="Extension_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Use_" msprop:Generator_ColumnVarNameInTable="columnUse_" msprop:Generator_ColumnPropNameInRow="Use_" msprop:Generator_ColumnPropNameInTable="Use_Column" msprop:Generator_UserColumnName="Use_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Equipment_" msprop:Generator_ColumnVarNameInTable="columnEquipment_" msprop:Generator_ColumnPropNameInRow="Equipment_" msprop:Generator_ColumnPropNameInTable="Equipment_Column" msprop:Generator_UserColumnName="Equipment_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidFrom_" msprop:Generator_ColumnVarNameInTable="columnValidFrom_" msprop:Generator_ColumnPropNameInRow="ValidFrom_" msprop:Generator_ColumnPropNameInTable="ValidFrom_Column" msprop:Generator_UserColumnName="ValidFrom_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ValidUntil_" msprop:Generator_ColumnVarNameInTable="columnValidUntil_" msprop:Generator_ColumnPropNameInRow="ValidUntil_" msprop:Generator_ColumnPropNameInTable="ValidUntil_Column" msprop:Generator_UserColumnName="ValidUntil_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PatientNote_" msprop:Generator_TableClassName="PatientNote_DataTable" msprop:Generator_TableVarName="tablePatientNote_" msprop:Generator_TablePropName="PatientNote_" msprop:Generator_RowDeletingName="PatientNote_RowDeleting" msprop:Generator_UserTableName="PatientNote_" msprop:Generator_RowChangingName="PatientNote_RowChanging" msprop:Generator_RowEvHandlerName="PatientNote_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientNote_RowDeleted" msprop:Generator_RowEvArgName="PatientNote_RowChangeEvent" msprop:Generator_RowChangedName="PatientNote_RowChanged" msprop:Generator_RowClassName="PatientNote_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="PatientOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPatientOID_" msprop:Generator_ColumnPropNameInRow="PatientOID_" msprop:Generator_ColumnPropNameInTable="PatientOID_Column" msprop:Generator_UserColumnName="PatientOID_" type="xs:string" />
              <xs:element name="CreationTime_" msprop:Generator_ColumnVarNameInTable="columnCreationTime_" msprop:Generator_ColumnPropNameInRow="CreationTime_" msprop:Generator_ColumnPropNameInTable="CreationTime_Column" msprop:Generator_UserColumnName="CreationTime_" type="xs:dateTime" />
              <xs:element name="AuthorOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnAuthorOID_" msprop:Generator_ColumnPropNameInRow="AuthorOID_" msprop:Generator_ColumnPropNameInTable="AuthorOID_Column" msprop:Generator_UserColumnName="AuthorOID_" type="xs:string" />
              <xs:element name="CategoryOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCategoryOID_" msprop:Generator_ColumnPropNameInRow="CategoryOID_" msprop:Generator_ColumnPropNameInTable="CategoryOID_Column" msprop:Generator_UserColumnName="CategoryOID_" type="xs:string" />
              <xs:element name="Comment_" msprop:Generator_ColumnVarNameInTable="columnComment_" msprop:Generator_ColumnPropNameInRow="Comment_" msprop:Generator_ColumnPropNameInTable="Comment_Column" msprop:Generator_UserColumnName="Comment_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidFrom_" msprop:Generator_ColumnVarNameInTable="columnValidFrom_" msprop:Generator_ColumnPropNameInRow="ValidFrom_" msprop:Generator_ColumnPropNameInTable="ValidFrom_Column" msprop:Generator_UserColumnName="ValidFrom_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ValidUntil_" msprop:Generator_ColumnVarNameInTable="columnValidUntil_" msprop:Generator_ColumnPropNameInRow="ValidUntil_" msprop:Generator_ColumnPropNameInTable="ValidUntil_Column" msprop:Generator_UserColumnName="ValidUntil_" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PatientNoteCategory_" msprop:Generator_TableClassName="PatientNoteCategory_DataTable" msprop:Generator_TableVarName="tablePatientNoteCategory_" msprop:Generator_TablePropName="PatientNoteCategory_" msprop:Generator_RowDeletingName="PatientNoteCategory_RowDeleting" msprop:Generator_UserTableName="PatientNoteCategory_" msprop:Generator_RowChangingName="PatientNoteCategory_RowChanging" msprop:Generator_RowEvHandlerName="PatientNoteCategory_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientNoteCategory_RowDeleted" msprop:Generator_RowEvArgName="PatientNoteCategory_RowChangeEvent" msprop:Generator_RowChangedName="PatientNoteCategory_RowChanged" msprop:Generator_RowClassName="PatientNoteCategory_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="Name_" msprop:Generator_ColumnVarNameInTable="columnName_" msprop:Generator_ColumnPropNameInRow="Name_" msprop:Generator_ColumnPropNameInTable="Name_Column" msprop:Generator_UserColumnName="Name_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_" msprop:Generator_ColumnVarNameInTable="columnDescription_" msprop:Generator_ColumnPropNameInRow="Description_" msprop:Generator_ColumnPropNameInTable="Description_Column" msprop:Generator_UserColumnName="Description_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Severity_" msprop:Generator_ColumnVarNameInTable="columnSeverity_" msprop:Generator_ColumnPropNameInRow="Severity_" msprop:Generator_ColumnPropNameInTable="Severity_Column" msprop:Generator_UserColumnName="Severity_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Patient_" msprop:Generator_TableClassName="Patient_DataTable" msprop:Generator_TableVarName="tablePatient_" msprop:Generator_TablePropName="Patient_" msprop:Generator_RowDeletingName="Patient_RowDeleting" msprop:Generator_UserTableName="Patient_" msprop:Generator_RowChangingName="Patient_RowChanging" msprop:Generator_RowEvHandlerName="Patient_RowChangeEventHandler" msprop:Generator_RowDeletedName="Patient_RowDeleted" msprop:Generator_RowEvArgName="Patient_RowChangeEvent" msprop:Generator_RowChangedName="Patient_RowChanged" msprop:Generator_RowClassName="Patient_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InformationAuthorityEnum_" msprop:Generator_TableClassName="InformationAuthorityEnum_DataTable" msprop:Generator_TableVarName="tableInformationAuthorityEnum_" msprop:Generator_TablePropName="InformationAuthorityEnum_" msprop:Generator_RowDeletingName="InformationAuthorityEnum_RowDeleting" msprop:Generator_UserTableName="InformationAuthorityEnum_" msprop:Generator_RowChangingName="InformationAuthorityEnum_RowChanging" msprop:Generator_RowEvHandlerName="InformationAuthorityEnum_RowChangeEventHandler" msprop:Generator_RowDeletedName="InformationAuthorityEnum_RowDeleted" msprop:Generator_RowEvArgName="InformationAuthorityEnum_RowChangeEvent" msprop:Generator_RowChangedName="InformationAuthorityEnum_RowChanged" msprop:Generator_RowClassName="InformationAuthorityEnum_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code_" msprop:Generator_ColumnVarNameInTable="columnCode_" msprop:Generator_ColumnPropNameInRow="Code_" msprop:Generator_ColumnPropNameInTable="Code_Column" msprop:Generator_UserColumnName="Code_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value_" msprop:Generator_ColumnVarNameInTable="columnValue_" msprop:Generator_ColumnPropNameInRow="Value_" msprop:Generator_ColumnPropNameInTable="Value_Column" msprop:Generator_UserColumnName="Value_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_" msprop:Generator_ColumnVarNameInTable="columnDescription_" msprop:Generator_ColumnPropNameInRow="Description_" msprop:Generator_ColumnPropNameInTable="Description_Column" msprop:Generator_UserColumnName="Description_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayOrder_" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder_" msprop:Generator_ColumnPropNameInRow="DisplayOrder_" msprop:Generator_ColumnPropNameInTable="DisplayOrder_Column" msprop:Generator_UserColumnName="DisplayOrder_" type="xs:float" minOccurs="0" />
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientProfile_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="PatientProfileAddress__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientProfileAddress_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="PatientProfileContactPerson__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientProfileContactPerson_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="PatientProfileEmailAddress__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientProfileEmailAddress_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="PatientProfileTelephoneNumber__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientProfileTelephoneNumber_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="PatientNote__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientNote_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="PatientNoteCategory__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientNoteCategory_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="Patient__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Patient_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="InformationAuthorityEnum__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:InformationAuthorityEnum_" />
      <xs:field xpath="mstns:Code_" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_PatientProfileOID_48E8A8F216EEC3B1EF8E9BBD6B0615FA" msdata:parent="PatientProfile_" msdata:child="PatientProfileAddress_" msdata:parentkey="OID_" msdata:childkey="PatientProfileOID_" msprop:Generator_UserChildTable="PatientProfileAddress_" msprop:Generator_ChildPropName="GetPatientProfileAddress_Rows" msprop:Generator_UserParentTable="PatientProfile_" msprop:Generator_UserRelationName="FK_PatientProfileOID_48E8A8F216EEC3B1EF8E9BBD6B0615FA" msprop:Generator_RelationVarName="relationFK_PatientProfileOID_48E8A8F216EEC3B1EF8E9BBD6B0615FA" msprop:Generator_ParentPropName="PatientProfile_Row" />
      <msdata:Relationship name="FK_PatientProfileOID_30E0CDC53C23CFEFAAC08A1B280ED4A4" msdata:parent="PatientProfile_" msdata:child="PatientProfileContactPerson_" msdata:parentkey="OID_" msdata:childkey="PatientProfileOID_" msprop:Generator_UserChildTable="PatientProfileContactPerson_" msprop:Generator_ChildPropName="GetPatientProfileContactPerson_Rows" msprop:Generator_UserParentTable="PatientProfile_" msprop:Generator_UserRelationName="FK_PatientProfileOID_30E0CDC53C23CFEFAAC08A1B280ED4A4" msprop:Generator_RelationVarName="relationFK_PatientProfileOID_30E0CDC53C23CFEFAAC08A1B280ED4A4" msprop:Generator_ParentPropName="PatientProfile_Row" />
      <msdata:Relationship name="FK_PatientProfileOID_995CCD42F22C902F73A4054805FB5B41" msdata:parent="PatientProfile_" msdata:child="PatientProfileEmailAddress_" msdata:parentkey="OID_" msdata:childkey="PatientProfileOID_" msprop:Generator_UserChildTable="PatientProfileEmailAddress_" msprop:Generator_ChildPropName="GetPatientProfileEmailAddress_Rows" msprop:Generator_UserParentTable="PatientProfile_" msprop:Generator_UserRelationName="FK_PatientProfileOID_995CCD42F22C902F73A4054805FB5B41" msprop:Generator_RelationVarName="relationFK_PatientProfileOID_995CCD42F22C902F73A4054805FB5B41" msprop:Generator_ParentPropName="PatientProfile_Row" />
      <msdata:Relationship name="FK_PatientProfileOID_DA2A8F24E9EEED134B5EFC2E6F5602CB" msdata:parent="PatientProfile_" msdata:child="PatientProfileTelephoneNumber_" msdata:parentkey="OID_" msdata:childkey="PatientProfileOID_" msprop:Generator_UserChildTable="PatientProfileTelephoneNumber_" msprop:Generator_ChildPropName="GetPatientProfileTelephoneNumber_Rows" msprop:Generator_UserParentTable="PatientProfile_" msprop:Generator_UserRelationName="FK_PatientProfileOID_DA2A8F24E9EEED134B5EFC2E6F5602CB" msprop:Generator_RelationVarName="relationFK_PatientProfileOID_DA2A8F24E9EEED134B5EFC2E6F5602CB" msprop:Generator_ParentPropName="PatientProfile_Row" />
      <msdata:Relationship name="FK_CategoryOID_E06728DC8E6EA3BAE9AB9147546F4CC9" msdata:parent="PatientNoteCategory_" msdata:child="PatientNote_" msdata:parentkey="OID_" msdata:childkey="CategoryOID_" msprop:Generator_UserChildTable="PatientNote_" msprop:Generator_ChildPropName="GetPatientNote_Rows" msprop:Generator_UserParentTable="PatientNoteCategory_" msprop:Generator_UserRelationName="FK_CategoryOID_E06728DC8E6EA3BAE9AB9147546F4CC9" msprop:Generator_RelationVarName="relationFK_CategoryOID_E06728DC8E6EA3BAE9AB9147546F4CC9" msprop:Generator_ParentPropName="PatientNoteCategory_Row" />
      <msdata:Relationship name="FK_PatientOID_1730B951630835E3F5FF1D644E86EFCA" msdata:parent="Patient_" msdata:child="PatientProfile_" msdata:parentkey="OID_" msdata:childkey="PatientOID_" msprop:Generator_UserChildTable="PatientProfile_" msprop:Generator_ChildPropName="GetPatientProfile_Rows" msprop:Generator_UserParentTable="Patient_" msprop:Generator_UserRelationName="FK_PatientOID_1730B951630835E3F5FF1D644E86EFCA" msprop:Generator_RelationVarName="relationFK_PatientOID_1730B951630835E3F5FF1D644E86EFCA" msprop:Generator_ParentPropName="Patient_Row" />
      <msdata:Relationship name="FK_PatientOID_6D3B89CEF6EC48CECD7F9F47A8DAB4F0" msdata:parent="Patient_" msdata:child="PatientNote_" msdata:parentkey="OID_" msdata:childkey="PatientOID_" msprop:Generator_UserChildTable="PatientNote_" msprop:Generator_ChildPropName="GetPatientNote_Rows" msprop:Generator_UserParentTable="Patient_" msprop:Generator_UserRelationName="FK_PatientOID_6D3B89CEF6EC48CECD7F9F47A8DAB4F0" msprop:Generator_RelationVarName="relationFK_PatientOID_6D3B89CEF6EC48CECD7F9F47A8DAB4F0" msprop:Generator_ParentPropName="Patient_Row" />
      <msdata:Relationship name="FK_MrnAssigningAuthority_C9A418FBED76CD44D192417621C14713" msdata:parent="InformationAuthorityEnum_" msdata:child="PatientProfile_" msdata:parentkey="Code_" msdata:childkey="MrnAssigningAuthority_" msprop:Generator_UserChildTable="PatientProfile_" msprop:Generator_ChildPropName="GetPatientProfile_Rows" msprop:Generator_ParentPropName="InformationAuthorityEnum_Row" msprop:Generator_UserRelationName="FK_MrnAssigningAuthority_C9A418FBED76CD44D192417621C14713" msprop:Generator_RelationVarName="relationFK_MrnAssigningAuthority_C9A418FBED76CD44D192417621C14713" msprop:Generator_UserParentTable="InformationAuthorityEnum_" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>